CREATE OR REPLACE PACKAGE pkg_logger IS
/*****************************************************************************
* Name : pkg_logger
* Type : Package specification
* Description : For logging progress and error messages of PL/SQL component
*
* Copyright : VocaLink
*
* Amendment History :
*
* Version  Date         Changed By     Reason (e.g. Initial, Change Ref)
******************************************************************************
* 1.0      01/08/2007   Rajeeva Tiwari  Common component.
*****************************************************************************/

   --
   -- Logs the debug message in progress_log
   --

   PROCEDURE log_progress( p_package_name       IN t_progress_log.package_name%TYPE
                         , p_procedure_name     IN t_progress_log.procedure_name%TYPE
                         , p_progress_message   IN t_progress_log.progress_message%TYPE
                         , p_stage              IN t_progress_log.stage%TYPE DEFAULT NULL
                         , p_work_identifier    IN t_progress_log.work_identifier%TYPE DEFAULT NULL);

   --
   -- Logs ems and other error messages
   --

   PROCEDURE log_error( p_package_name          IN t_error_log.package_name%TYPE
                      , p_procedure_name        IN t_error_log.procedure_name%TYPE
                      , p_app_error_message     IN t_error_log.app_error_message%TYPE
                      , p_oracle_message        IN t_error_log.oracle_message%TYPE
                      , p_ems_code              IN t_error_log.ems_code%TYPE DEFAULT NULL);

END pkg_logger;
/
